package org.mcflier.appuntamento.io.driver.db.interfaces;


public interface IJDBCDriver extends IJDBCMovieDriver, IJDBCGenreDriver, IJDBCProductionDriver, IJDBCCountryDriver, IJDBCLanguageDriver {
	public static final String PROPERTIES_FILENAME = "db.properties";
	public static final String USER_KEY = "user";
	public static final String PASSWORD_KEY = "password";
	public static final String JDBC_URL_KEY ="jdbc_url";
	public static final String JDBC_DRIVER = "jdbc_driver";
	
	public static final String MOVIE_TABLE = "movie";
	public static final String MOVIE_IDMOVIE = "idMovie";
	public static final String MOVIE_ORIGINAL_TITLE = "originalTitle";
	public static final String MOVIE_POSTER_PATH = "posterPath";
	public static final String MOVIE_HOMEPAGE = "homepage";
	public static final String MOVIE_RUNTIME = "runtime";
	public static final String MOVIE_RELEASE_DATE = "releaseDate";
	public static final String MOVIE_TRACED = "traced";
	
	public static final String GENRE_TABLE = "genre";
	public static final String GENRE_ID = "idgenre";
	public static final String GENRE_NAME = "name";
	
	public static final String COUNTRY_TABLE = "country";
	public static final String COUNTRY_CODE = "code";
	public static final String COUNTRY_NAME = "name";
	
	public static final String LANGUAGE_TABLE = "language";
	public static final String LANGUAGE_CODE = "code";
	public static final String LANGUAGE_NAME = "name";
	
	public static final String PRODUCTION_TABLE = "production";
	public static final String PRODUCTION_IDPRODUCTION = "idproduction";
	public static final String PRODUCTION_NAME = "name";
	
	public static final String MOVIE_GENRE_TABLE = "movie_genre";
	public static final String MOVIE_GENRE_IDMOVIE = "movie_idMovie";
	public static final String MOVIE_GENRE_IDGENRE = "genre_idGenre";
	
	public static final String MOVIE_LANGUAGE_TABLE = "movie_language";
	public static final String MOVIE_LANGUAGE_IDMOVIE = "movie_idmovie";
	public static final String MOVIE_LANGUAGE_LANGUAGE_CODE = "language_code";
	public static final String MOVIE_LANGUAGE_OVERVIEW = "overview";
	public static final String MOVIE_LANGUAGE_ALTERNATIVE_TITLE = "alternativetitle";
	public static final String MOVIE_LANGUAGE_TAGLINE = "tagline";
	
	public static final String MOVIE_PRODUCTION_TABLE = "movie_production";	
	public static final String MOVIE_PRODUCTION_IDMOVIE = "movie_idmovie";
	public static final String MOVIE_PRODUCTION_IDPRODUCTION = "production_idproduction";
	
	public static final String COUNTRY_PRODUCTION_TABLE = "country_production";
	public static final String COUNTRY_PRODUCTION_IDMOVIE = "movie_idmovie";
	public static final String COUNTRY_PRODUCTION_COUNTRY_CODE = "country_code";
	
	public static final String TRACING_TABLE = "Tracing";
	public static final String TRACING_IDMOVIE = "movie_idmovie";
	public static final String TRACING_ADDEDBY = "addedby";
	public static final String TRACING_ADDEDATE = "addedate";
	public static final String TRACING_TRACINGLANGUAGE = "tracinglanguage";
	public static final String TRACING_TRACED = "traced";
	public static final String TRACING_TRACEDDATE = "traceddate";
	public static final String TRACING_SOURCE = "source";
	public static final String TRACING_LINK = "link";
}
